The Business Master (4th Edition)

home *** CD-ROM | disk | FTP | other *** search

/ The Business Master (4th Edition) / The Business Master - 4th Edition.iso / files / busition / propman3 / reports.doc < prev next >

Wrap

Text File | 1993-09-27 | 24.1 KB | 602 lines

Demo Building Account Activity Beverly (765) - Expense Accounts April 1991 1200 UTILITIES 1210 Electricity 0.00 1220 Water 161.48 1230 Gas 0.00 1250 Utility Tax 0.00 161.48 1300 FIXED EXPENSES 1310 Rubbish Removal 253.69 1320 Gardening 270.00 1370 Sewer 0.00 523.69 1400 MAINTENENCE/ REPAIRS 1410 Plumbing 0.00 1420 Heat/Air Conditioner 0.00 1430 Electrical 28.67 1440 Building 40.26 1450 Roofing 1,795.82 1460 Painting 0.00 1470 Windows/ Screens 0.00 1480 Yard supplies 0.00 1,864.75 1500 DECORATING 1510 Cleaning - Apartment 0.00 1520 Clean/Repl Cpt/ Drp 209.99 1530 Painting 0.00 1540 Fixtures 0.00 1550 Yard 0.00 1560 Building 93.48 303.47 1600 TAXES/ INSURANCE 1610 Real Estate Taxes 873.02 1620 Fire Insurance 0.00 1630 Liability Ins. 0.00 1640 Earthquake Ins. 0.00 873.02 1700 MGMNT/ SUNDRY EXP 1710 Management Fees 0.00 1720 Rent Credit Given 540.00 1730 Mileage@.275/ Travel 50.88 1750 Office Supplies 36.00 1760 Legal / Accntng Fees 300.00 1770 Telephone 36.85 1780 Office help/cleaning 240.00 1790 Miscellaneous 0.00 1,203.73 ----------- Operating expenses total 4,930.14 Demo Building Account Activity Beverly (765) - Expense Accounts April 1991 1800 REPLACEMENTS 1810 Carpets 0.00 1820 Drapes 241.80 1840 Building 7.67 1850 Equipment 14.53 1880 Tools 29.97 293.97 ----------- Replacements total 293.97 1900 DEPOSITS REFUNDED 0.00 ----------- Deposit refunds total 0.00 2000 MORTGAGE PRIN/ FEES 2010 1st T.D. Principal 618.53 2030 3rd T.D. Principal 473.42 2060 Late Fees 0.00 1,091.95 2100 MORTGAGE INTEREST 2110 1st T.D. Interest 2,846.07 2130 3rd T.D. Interest 2,126.58 4,972.65 2200 MORTGAGE IMPOUNDS 2210 1st T.D. Impound 325.64 2230 3rd T.D. Impound 0.00 325.64 ----------- Mortgage expense total 6,390.24 Disbursements total 11,614.35 2300 TO RESERVES 0.00 ----------- Cash to reserves total 0.00 2400 TO OWNER 2410 Cash to Owner 3,482.87 3,482.87 ----------- Cash to owners total 3,482.87 ----------- Total cash used 15,097.22 =========== Demo Building Account Activity Beverly (765) - Income Accounts April 1991 2500 INCOME 2510 Rents 12,870.00 2520 Apt. Allowance 0.00 2530 Rent Credit 540.00 2540 L-M-R Used 0.00 2550 Other 0.00 13,410.00 2600 DEPOSITS COLLECTED 0.00 ----------- Collections total 13,410.00 2700 FROM RESERVES 2710 General 0.00 2720 Taxes 0.00 2730 Insurance 1,687.22 2740 Roofing 0.00 2750 Painting 0.00 1,687.22 ----------- Cash from reserves total 1,687.22 2800 FROM OWNER 2810 Cash from Owner 0.00 0.00 ----------- Cash from owners total 0.00 ----------- Total cash available 15,097.22 =========== Demo Building Account Activity Beverly (765) - Account Balances April 1991 MORTGAGE BALANCES 1st T.D. 3,882,083.29 3rd T.D. 2,047,277.36 5,929,360.65 RESERVE BALANCES General 0.00 Taxes 162.00 Insurance 3,530.00 Roofing 0.00 Painting 800.00 4,492.00 DEPOSIT BALANCES General 14,058.34 L-M-R (Lst Mnth Rnt) 0.00 14,058.34 Sample Building Building Reference Listings Main St.(121) Number of units: 4 Address: 12138 Main St. : El Monte, CA : 91734 : <------------- Reserve Accounts -----------> Amount Balance Notes General 0.00 1,796.37 Cleaning: Taxes 0.00 0.00 Electric: Insurance 100.00 200.00 Gardener: None Roofing 0.00 0.00 Gas : Painting 0.00 0.00 Paint : 1987 Plumber : Pool : No Rubbish : C & H Disp Water : San Gab Valley Wat UNITS 12138 12140 12142 12144 MORTGAGES 1 World Savings and Loan (800) 642-0257 x (415) 944-7600 x Loan Balance: 335,546.11 Interest rate: 9.50 % Due day: 15 Princ. & Int. 4,356.20 Impound: 173.70 Account: 123-ABC Total Payment: 4,529.90 Terms: 30yr Fix Rate 2 Chrysler First Financial (714) 547-0824 x Loan Balance: 47,562.60 Interest rate: 13.67 % Due day: 12 Princ. & Int. 650.00 Impound: 0.00 Account: A-0744835128-7 Total Payment: 650.00 Terms: due 2008, $573 min/mo Sample Building Fallon Ave (671) - Invoice Detail March 1991 Num Vendor Name(#) Due Amount Status Paid/Hld Description Dist. Account Amount 1 L.A. County Tax ( 12) 04/10/91 130.61 Hold 02/26/91 Property Tax 1610 Real Estate Taxes 130.61 2 G. C. Feger ( 19) 03/03/91 27.50 Paid 04/02/91 Mileage 100 mi F 1730 Mileage@.275/ Travel 27.50 3 World Savings an( 1) 3/15/91 430.00 Paid 03/03/91 Mortgage Payment 2010 1st T.D. Principal 74.79 2110 1st T.D. Interest 281.41 2210 1st T.D. Impound 73.80 4 Sears ( 21) 03/03/91 75.00 Paid 03/03/91 12138 roof 1450 Roofing 75.00 5 G. C. Feger ( 19) 03/13/91 7.67 Paid 04/02/91 Locks 1840 Building 7.67 6 Cash 03/18/91 1,495.82 Paid 04/02/91 Carport roofs 40 1450 Roofing 1,495.82 7 San Gabriel Vall( 6) 04/02/91 61.12 Paid 04/02/91 Water 1220 Water 61.12 8 G. C. Feger ( 19) 04/02/91 14.53 Paid 04/02/91 Shelf brackets 1850 Equipment 14.53 9 Tran, Ho( 2) 04/02/91 100.00 Paid 04/02/91 Gardener Feb/Mar 1320 Gardening 100.00 10 City of Monterey( 5) 04/02/91 57.82 Paid 04/02/91 Water/ Trash 1220 Water 25.66 1310 Rubbish Removal 32.16 11 Pacific Bell ( 4) 04/02/91 12.36 Paid 04/02/91 Phone 1770 Telephone 12.36 PropMan Demo System 309 S. Ynez Ave. Monterey Park, CA Sample Building(456) - Recap 6/27/91 June 1991 BUILDING OPERATIONS Income Disbursements Rents 7,280 Operating expense 1,197 Apt. Allowance 0 Replacements 112 Rent Credit 0 Deposit refunds 0 L-M-R Used 0 Mortgages 2,740 Other 135 Deposit coll 380 ------------- ------------ Total Collections 7,795 Total Disbursements 4,049 SOURCE AND USE OF FUNDS Total collections 7,795 Total disbursements 4,049 3,746 Operating Income Cash from reserves 0 Cash to reserves 570 570 To reserves Cash from owners 0 Cash to owners 3,176 3,176 To owners -------------- ----------- Total cash available 7,795 Total cash used 7,795 ---------------------------------------------------------------------------- ACCOUNT BALANCES Deposits Reserves Mortgages Security 8,185 General 940 1st T.D. 537,445 Pet 1,450 Taxes 2,678 2nd T.D. 74,672 Insurance 3,900 L-M-R 4,850 PropMan Demo System 309 S. Ynez Ave. Monterey Park, CA Sample Building(456) 6/27/91 Income by Unit June 1991 < Amounts Due >< Amounts Paid > Other Monthly Other Rent Balance Paid Unit ID In/ Out Rent Due To 101 Prev Bal 135.00 135.00 1,560.00 1,560.00 6/30 102 Deposit 380.00 22 1,610.00 1,610.00 7/21 103 1,500.00 1,400.00 100.00 5/31 104 1,410.00 1,410.00 6/30 105 1,500.00 1,270.00 230.00 5/31 TOTALS Scheduled rent 7,580.00 Rent collections 7,250.00 95.6% of scheduled rent Apartment allowances 0.00 Rent credit 0.00 Deposit collections 380.00 Other unit collections 135.00 Delinquent rent 330.00 PropMan Demo System 309 S. Ynez Ave. Monterey Park, CA Sample Building(456) - June 1991 6/27/91 Income / Expense Percentage Analysis Current Month Year to Date Account Name(Number) Amount Prcnt Amount Pcnt Gross scheduled rent 7,580 100.0 45,480 100.0 Income Rents(2510) 7,250 95.6 44,870 98.7 Other(2550) 135 1.8 540 1.2 Total Income 7,385 97.4 45,410 99.8 Expenses Water(1220) 240 3.2 1,112 2.4 Rubbish removal(1310) 80 1.1 480 1.1 Gardening(1320 110 1.5 735 1.6 Plumbing(1410) 0 0.0 1,487 3.3 Electrical(1430) 380 5.0 678 1.5 Painting(1460) 286 3.8 502 1.1 Windows/ Screens(1470) 43 0.6 189 0.4 Yard supplies(1480) 58 0.7 305 0.7 Real Estate Taxes(1610) 0 0.0 1,883 4.1 Building(1840) 0 0.0 761 1.7 Tools(1880) 0 0.0 285 0.6 Miscellaneous(1890) 112 1.5 556 1.2 Total expense 1,309 17.3 8,973 19.7 Net Income 6,076 80.2 36,437 80.1 Other activity 1st T.D.(2010,2110) 2,206 29.1 13,236 29.1 2nd T.D.(2020,2120) 534 7.0 3,204 7.0 Deposits, Net Received 380 5.8 548 1.2 Net cash flow 3,716 49.0 20,545 45.2 PropMan Demo System 309 S. Ynez Ave. Monterey Park, CA Prcssng Mth Tenant Reference Listing 6/27/91 June Sample Building(456) Unit: 101 Tenant: Doe, Jane Status: Current Deposit Balances Date in: 01/01/91 General : 800.00 Sched rent: 1,560.00 Lease exp: 12/30/91 Pet : 250.00 Due day: 1 Pay / Quit: / / : 0.00 Paid to: 6/30/91 Date out: / / : 0.00 Close: No L-M-R : 0.00 Rent Date Phone Rent due: 0.00 Last: 0.00 / / (123) 456-7890 Other due: 0.00 Next: 0.00 / / Other Occupants Garage: A-21, A-22 Doe, William Jr. Locker: A-21 Car: 1990 Blue Chrysler, ABC-123 : 1991 Red Ford PU, DEF-456 < - - Tenant's Employer - - > < - - Spouse's Employer - - > Name: Nice Guy,s Inc. Name: Address: 1234 Main St. Address: : Somewherein, CA : : 91234 : : : Phone: (714) 555-6677 Phone: Activity History Date $ Amount Type Desc 12/13/90 800.00 Gnrl Payment Sec deposit 12/13/90 250.00 Pet Payment 1 small dog is OK 12/28/90 1,000.00 Rent Payment Jan rent 01/03/91 560.00 Rent Credit Cr for them painting apt 02/11/91 1,560.00 Rent Payment warned about late rent 03/03/91 1,560.00 Rent Payment 04/ 1/91 1,560.00 Rent Payment 05/10/91 50.00 Othr Assmnt Charge for carpet cleaning 05/17/91 50.00 Othr Payment paid for cleaning 06/03/91 1,560.00 Rent Payment PropMan Demo System 309 S. Ynez Ave. Monterey Park, CA Prcssng Mth Unit Reference Listing 6/27/90 June Sample Building(456) Unit Current Tenant Scheduled Rent Last Change 101 Doe, Jane 1,560.00 06/30/89 Notes Carpet : 6/86 Carpet tan/brown Disposal: 3/84 Bath and kitch, yellow/brown Dsh wshr: 3/85 Tile entry hall Drapes : Cleaned 8/87 New bath tile in 7/86 Heater : Wall unit Paint : New 8/87 Yard, redwood fence Refrig : Tenant Tenant pays gardener Roof : 2/82 Stove : Original Wtr Htr : Original Sample Building Over Due Rent List Schd Due Due Notice Amount Unit Tenant Rent From To Date Over due Building: 121 Main St. 12138 Whositz, G 325.00 02/01/91 03/31/91 02/18/91 750.00 12144 Pope, K 625.00 03/01/91 03/31/91 / / 625.00 Sample Building Pending Rent Changes Current Rent Pending Rent Unit Tenant Date Amount Date Amount Building: 309 Central A Sorbel, Eve 03/15/90 425.00 04/15/91 475.00 D Geltz, Steve 06/01/90 665.00 06/01/91 710.00 Sample Building Tenant Rent Roll Main St.(121) Paid Sched Due Total Due Amount Unit Tenant To Rent Day This Month Paid Date 12138 Winick, 03/91 900.00 1 0.00 --------- ------- 12140 Zalez, 03/91 750.00 15 750.00 --------- ------- 12142 Hernandez, 03/91 875.00 15 875.00 --------- ------- 12144 Hope, 02/91 1,325.00 1 2,650.00 --------- ------- Sample Building Unit Reference Listing Main St.(121) Unit Current Tenant Scheduled Rent Last Change 12138 Winick, Darryl & Liz 500.00 08/20/91 Notes Carpet : new 8/91, 54 Yds Rear of 4, 1Br, 1Ba, Lrg LR Disposal: No Lrg Yard, Dbl Gar Dsh wshr: No Drapes : Mini blinds 1987 6/91 Fume & Treat for Termites Heater : Wall Bath wallboard 1986 Paint : 1987 Kit/1989 rest Refrig : No 12138 Main St. Roof : Hse & Gar 5/91 El Monte, CA Stove : No 91734 Wtr Htr : 1986 Used Unit Current Tenant Scheduled Rent Last Change 12140 Zalez, Ramona 550.00 02/15/90 Notes Carpet : Replace 1/90 3rd of 4, 2Br, 1Ba, Lrg LR Disposal: Yes Fncd Yard, CPt, Shed Dsh wshr: No Drapes : No Carport roof removed 1/91 Heater : Wall, valve 12/87 Kt/Bth floor 12/90 Paint : Int 12/90 Refrig : No 12140 Main St. Roof : 1/80 Alh Sears El Monte, CA Stove : No 91734 Wtr Htr : Unit Current Tenant Scheduled Rent Last Change 12142 Hernandez, Philip 675.00 12/15/91 Notes Carpet : New 9/91, 84 Yds Older 2Br, 1Ba, Fncd Yard Disposal: 1988 Atch Dbl Gar, Lrg LR Dsh wshr: No Drapes : No Heater : Forced Air Rcd $1070 from Ins 2/90 Paint : Ex 1986 / Int 9/91 Bath vinyl wall 11/87 Refrig : No 12142 Main St. Roof : El Monte, CA Stove : 91734 Wtr Htr : Sample Building Unit Reference Listing Main St.(121) Unit Current Tenant Scheduled Rent Last Change 12144 Hope, Kurt 625.00 12/18/91 Notes Carpet : Dec 1989, Inc K Tile Front 2Br, 1Ba, Fncd Yard Disposal: Yes/ ^68 Yds Lrg LR, CPt Dsh wshr: No Drapes : No Heater : Wall Paint : Int 1989, ex frt br Refrig : No 12144 Main St. Roof : Est 1980 El Monte, CA Stove : No 91734 Wtr Htr :